﻿///***************************************************************
/// 시  스  템 : Updms.Crd.Dac
/// 단위시스템 : CRD
/// 계      층 : Data Access Layer
/// 프로그램명 : Crd_Dac_UPDMS_CRD_INSTALLMENT_REPAY
/// 파  일  명 : Crd_Dac_UPDMS_CRD_INSTALLMENT_REPAY.cs
/// 설      명 : 할부상환관리
///***************************************************************
/// 수정ID 일자       이름     내용
///---------------------------------------------------------------
/// CH001  2008-07-21 송시명   최초 작성
///***************************************************************
using System.Data;
using System.Data.SqlClient;
using System.EnterpriseServices;
using System.Runtime.InteropServices;

using SMFramework.Data;


namespace Updms.Crd.Dac
{
	[ComVisible(true)]
	[Transaction(TransactionOption.Supported)]
	[JustInTimeActivation(true)]
	public class Crd_Dac_UPDMS_CRD_INSTALLMENT_REPAY : Base.AppFramework.DacBase
	{
		public Crd_Dac_UPDMS_CRD_INSTALLMENT_REPAY()
		{
		}
		
		#region NT [Select]
		
		[AutoComplete]
		public DataSet Select(string ls_card_cd, string ls_ins_cd)
		{
			string ls_sql = "usp_UPDMS_CRD_INSTALLMENT_REPAY_Select";

			SqlParameter[] paramArray =
			{
				new SqlParameter("ls_card_cd", ls_card_cd),
				new SqlParameter("ls_ins_cd", ls_ins_cd)
			};

			DataSet ds = new DataSet();
			return _agent.Fill(ls_sql, "UPDMS_CRD_INSTALLMENT_REPAY", ds, paramArray, CommandType.StoredProcedure);
		}
		
		#endregion

		#region RT [Update]
		
		[AutoComplete]
		public int Update(DataPack lo_dp)
		{
			string ls_sql = "usp_UPDMS_CRD_INSTALLMENT_REPAY_Update";

			SqlParameter[] paramArray = lo_dp.ToSqlParameters();
			return _agent.ExecuteNonQuery(ls_sql, paramArray, CommandType.StoredProcedure);
		}
		
		#endregion

		#region RT [Confirm]

		[AutoComplete]
		public int Confirm(DataPack lo_dp)
		{
			string ls_sql = "usp_UPDMS_CRD_INSTALLMENT_REPAY_Set_Confirm_Yn";

			SqlParameter[] paramArray = lo_dp.ToSqlParameters();

			return _agent.ExecuteNonQuery(ls_sql, paramArray, CommandType.StoredProcedure);
		}

		#endregion
		
	}
}
